﻿CREATE TABLE [dbo].[TemperatureDiary] (
    [TemperatureID]      INT             NOT NULL,
    [CityID]             INT             NOT NULL,
    [AverageTemperature] DECIMAL (18, 6) NOT NULL,
    [MinimumTemperature] DECIMAL (18, 6) NOT NULL,
    [MaximumTemperature] DECIMAL (18, 6) NOT NULL,
    [DateTimeStamp]      DATETIME        NOT NULL
);

